package org.jeecg.modules.yw.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.yw.entity.DataStatistic;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Mapper
public interface DataStatisticMapper extends BaseMapper<DataStatistic>{
	
	
	/**
	 * 查询数量是否存在
	 * @return
	 */
	@Select("select id, user_id, order_id, user_type, sl, tj_date from `data_statistic` where user_id = #{userId} and order_id = #{orderId} and type = #{type} ")
	public DataStatistic getSlExist(@Param("userId") String userId, @Param("orderId") String orderId, @Param("type") Integer type);
	
	
}
